SELECT
#fields

	*

#/fields

FROM
	<?php echo $this->adapter->getConfig()->table; ?> AS self

ORDER BY
	self.category, self.id

<?php if (!empty($this->paging)) : ?>

#limit

LIMIT
	<?php echo ($this->paging['page'] - 1) * $this->paging['perPage']; ?>, <?php echo $this->paging['perPage']; ?>

#/limit

<?php endif; ?>

